﻿CREATE TABLE [dbo].[ProductieArticoleOperatiuni] (
    [IDArticolOperatiune] INT        IDENTITY (1, 1) NOT NULL,
    [IDOperatiune]        INT        NOT NULL,
    [IDArticol]           INT        NOT NULL,
    [Intrare]             BIT        DEFAULT ((0)) NOT NULL,
    [Multiplicare]        FLOAT (53) DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_ProductieArticoleOperatiuni] PRIMARY KEY CLUSTERED ([IDArticolOperatiune] ASC),
    CONSTRAINT [FK_ProductieArticoleOperatiuni_Articole] FOREIGN KEY ([IDArticol]) REFERENCES [dbo].[Articole] ([IDArticol]),
    CONSTRAINT [FK_ProductieArticoleOperatiuni_ProductieOperatiuni] FOREIGN KEY ([IDOperatiune]) REFERENCES [dbo].[ProductieOperatiuni] ([IDOperatiune])
);

